﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Grain.Crm.ExcelExtractor.Input;

namespace Grain.Crm.ExcelExtractor.InputDescription.Sheets
{
    public class WorkingExperienceSheetDescription : SheetDescription
    {
        public int NextRecordRowDiff = 16;
        public int RecordsCount = 5;

        public void Build()
        {
            this.SheetName = "Working_experience";

            this.Descriptions.Add(new ValueDescription() { XlsDescription = "Title", CrmDisplayName = "Name", CrmEntity = CrmEntityName.ProfessionalExperience, Column = 3, Row = 5 });

            this.Descriptions.Add(new ValueDescription() { XlsDescription = "Company", CrmDisplayName = "Company", CrmEntity = CrmEntityName.ProfessionalExperience, Column = 3, Row = 6 });

            this.Descriptions.Add(new ValueDescription() { XlsDescription = "City", CrmDisplayName = "City", CrmEntity = CrmEntityName.ProfessionalExperience, Column = 3, Row = 7 });

            this.Descriptions.Add(new ValueDescription() { XlsDescription = "Country", CrmDisplayName = "Country", CrmEntity = CrmEntityName.ProfessionalExperience, Column = 3, Row = 8 });

            this.Descriptions.Add(new ValueDescription() { XlsDescription = "Job Title", CrmDisplayName = "Job Title", CrmEntity = CrmEntityName.ProfessionalExperience, Column = 3, Row = 9 });

            this.Descriptions.Add(new ValueDescription() { XlsDescription = "Number of subordinates", CrmDisplayName = "No. of subordinates", CrmEntity = CrmEntityName.ProfessionalExperience, Column = 3, Row = 10 });

            this.Descriptions.Add(new ValueDescription() { XlsDescription = "Start Date", CrmDisplayName = "Start Date", ParseDateAs = DateFormat.DaysSince1900, CrmEntity = CrmEntityName.ProfessionalExperience, Column = 3, Row = 11 });

            this.Descriptions.Add(new ValueDescription() { XlsDescription = "End Date", CrmDisplayName = "End Date", ParseDateAs = DateFormat.DaysSince1900, CrmEntity = CrmEntityName.ProfessionalExperience, Column = 3, Row = 12 });

            this.Descriptions.Add(new ValueDescription() { XlsDescription = "Reports to", CrmDisplayName = "Reports to", CrmEntity = CrmEntityName.ProfessionalExperience, Column = 3, Row = 13 });

            this.Descriptions.Add(new ValueDescription() { XlsDescription = "Salary", CrmDisplayName = "Salary", CrmEntity = CrmEntityName.ProfessionalExperience, Column = 3, Row = 14 });

            this.Descriptions.Add(new ValueDescription() { XlsDescription = "Job Description", CrmDisplayName = "Description", CrmEntity = CrmEntityName.ProfessionalExperience, Column = 3, Row = 15 });

            this.Descriptions.Add(new ValueDescription() { XlsDescription = "Technologies", CrmDisplayName = "Technologies", CrmEntity = CrmEntityName.ProfessionalExperience, Column = 3, Row = 16 });

            this.Descriptions.Add(new ValueDescription() { XlsDescription = "Additional benefits", CrmDisplayName = "Additional Benefits", CrmEntity = CrmEntityName.ProfessionalExperience, Column = 3, Row = 17 });

            this.Descriptions.Add(new ValueDescription() { XlsDescription = "Reason for leaving", CrmDisplayName = "Reason for leaving", CrmEntity = CrmEntityName.ProfessionalExperience, Column = 3, Row = 18 });
            

        }
    }
}
